Performance Recommendations

Cycle Recommendations

For optimum Client level cycle (07) activity processing following indexes needs to be applied:

S.No.	Column Name	Table Name
1	ACTIVITYGUID	ASACTIVITYSEQUENCEDETAIL
2	CLIENTRELATIONSHIPPARENTGUID	ASCLIENTRELATIONSHIP
3	CLIENTGUID	ASCYCLE

Redo Log File Sizing

In-order to get optimum performance, the redo log file should be sized in such a way that there should be around five log file switches per hour.